Using Inventory Inquiry
1. At the item field, enter the three digit item group for the item you are inquiring about or press F3 for a list of item groups.
A Select An Item window will display; scroll to the item and press Enter to select.
If you are uncertain of the item code, see Navigating Net Yield - Selecting an Item Code.
2. The screen displays the following fields:
- Item – The item code and name
- On Hand – The current on-hand quantity of this item. This includes all hold and non-hold lot amounts, less all shipped but un-invoiced sales orders for this item
- On Hold – The amount of the item in lots on hold
- On Order – The amount of the item on unshipped sales orders
- Shipped, Not Invoiced – The amount of the item on shipped but un-invoiced sales orders
- Cost – The current cost of the item. This will be zero if there is no inventory for them item
- Cost -1 – The first cost history bucket. This is the last cost used by Cost of Goods Sold
- Cost - 2 – The second cost history bucket.
- Cost - 3 – The third and oldest cost history bucket
- Last PO – The purchased cost of the item on the last completed purchase order, the last purchase order number, and last purchased date
- Next PO – The next open purchase order cost, the purchase order number, and the expected delivery date
- STD - The of the item
- Base 1 through Base 8 – The base selling price levels
- Price – The current base selling price for the item for each base price category
- Price -1 – The previous base selling price for the item for each base price category
- Date CHG – The last date that the base selling prices were updated.
3. The message line displays the following choices: Transactions, Transactions Between Dates, Labels (if the Inventory Labels setting has been set to Y (Y=yes) in Inventory Options for Inventory Inquiry) and Exit.
- Transactions – Select Transactions to inquire about inventory transaction information for this item . Similar to Inventory Transaction Inquiry except the inquiry is only for the item selected.
- Transactions Between Dates – Select Transactions Between Dates to inquire about inventory transaction information for this item between a set of dates. This option is similar to Inventory Dates Inquiry except the inquiry is only for the item selected.
- Labels – If the inventory label setting for the Inventory Inquiry is set to Y (Y=yes) in Inventory Options, select Labels, and enter the number of labels to print. See Labels for more information on printing labels.
- Exit – Select Exit to leave this option.
Use the Available Actions link for more information.
Security Required : Inventory - Inventory Inquiry
of the item